<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['batch']=array (
    'columns' =>
        array (
            'batch_id' =>
                array (
                    'type' => 'bigint unsigned',
                    'required' => true,
                    'pkey' => true,
                    'extra' => 'auto_increment',
                    'label' => '批次ID',
                    'width' => 110,
                    'hidden' => true,
                    'editable' => false,
                    'in_list' => false,
                ),
            'goods_id' =>
                array (
                    'type' => 'table:goods',
                    'required' => true,
                    'default' => 0,
                    'editable' => false,
                    'comment' => app::get('b2c')->_('商品ID'),
                ),
            'product_id' =>
                array (
                    'type' => 'table:products',
                    'required' => true,
                    'default' => 0,
                    'editable' => false,
                    'comment' => app::get('b2c')->_('货品ID'),
                ),
            'arrival_time'=>
                array (
                    'type' => 'time',
                    'label' => app::get('b2c')->_('到货日期'),
                    'width' => 110,
                    'editable' => false,
                    'filtertype' => 'yes',
                    'filterdefault' => true,
                    'in_list' => true,
                    'default_in_list' => true,
                    'comment' => app::get('b2c')->_('到货日期'),
                ),
            'batch' =>
                array (
                    'type' => 'varchar(20)',
                    'label' => app::get('b2c')->_('批次号'),
                    'width' => 110,
                    'editable' => false,
                    'filtertype' => 'yes',
                    'filterdefault' => true,
                    'in_list' => true,
                    'default_in_list' => true,
                    'comment' => app::get('b2c')->_('批次号'),
                ),
            'store' =>
                array (
                    'type' => 'number',
                    'label' => app::get('b2c')->_('库存'),
                    'default'=>0,
                    'width' => 30,
                    'editable' => false,
                    'filtertype' => 'number',
                    'filterdefault' => true,
                    'in_list' => true,
                    'comment' => app::get('b2c')->_('库存'),
                ),

        ),

    'engine' => 'innodb',
    'version' => '$Rev: 50001 $',
    'comment' => app::get('b2c')->_('商品批次表'),
);
